USE [totem]
GO

/****** Object:  StoredProcedure [dbo].[UPDRol]    Script Date: 05/25/2012 16:45:11 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[UPDRol]
@Identificador int,
@NombreRol varchar (50),
@TipoRol varchar (50),
@Descripcion varchar (200)

AS

BEGIN

	UPDATE ROL SET
		NOMBREROL = @NombreRol, TIPOROL = @TipoRol, DESCRIPCIONROL = @Descripcion
		where ID_ROL = @Identificador;
		
	
END

SET ANSI_NULLS ON
GO

